Dataset statistics
| Number of variables | 23 |
|---|---|
| Number of observations | 490962 |
| Missing cells | 980843 |
| Missing cells (%) | 8.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 86.2 MiB |
| Average record size in memory | 184.0 B |
Variable types
| Numeric | 9 |
|---|---|
| Categorical | 3 |
| DateTime | 3 |
| Text | 6 |
| Unsupported | 2 |
ACCESSORIAL_CHARGE is highly overall correlated with TOTAL_PAID | High correlation |
CARRIER_NAME2 is highly overall correlated with DUTIES_AND_TAXES_CHARGES and 2 other fields | High correlation |
DUTIES_AND_TAXES_CHARGES is highly overall correlated with CARRIER_NAME2 | High correlation |
HEIGHT is highly overall correlated with SHIP_WEIGHT and 1 other fields | High correlation |
LENGTH is highly overall correlated with SHIP_WEIGHT and 1 other fields | High correlation |
MODE is highly overall correlated with CARRIER_NAME2 and 1 other fields | High correlation |
SHIP_WEIGHT is highly overall correlated with HEIGHT and 2 other fields | High correlation |
TOTAL_PAID is highly overall correlated with ACCESSORIAL_CHARGE and 1 other fields | High correlation |
Unnamed: 0 is highly overall correlated with CARRIER_NAME2 | High correlation |
WIDTH is highly overall correlated with HEIGHT and 2 other fields | High correlation |
CARRIER_NAME2 is highly imbalanced (71.1%) | Imbalance |
SHIP_WEIGHT_UNIT_OF_MEASURE is highly imbalanced (68.5%) | Imbalance |
DELIVERY_DATE has 24481 (5.0%) missing values | Missing |
DESTINATION_CITY has 9362 (1.9%) missing values | Missing |
DESTINATION_RECEIVER_NAME2 has 21624 (4.4%) missing values | Missing |
DESTINATION_ZIP has 9393 (1.9%) missing values | Missing |
HEIGHT has 294158 (59.9%) missing values | Missing |
LENGTH has 294158 (59.9%) missing values | Missing |
SHIP_DATE has 14209 (2.9%) missing values | Missing |
SHIP_DATE_DAY_YEAR has 14209 (2.9%) missing values | Missing |
WIDTH has 294158 (59.9%) missing values | Missing |
ACCESSORIAL_CHARGE is highly skewed (γ1 = -32.24228866) | Skewed |
DUTIES_AND_TAXES_CHARGES is highly skewed (γ1 = 33.58318443) | Skewed |
TOTAL_PAID is highly skewed (γ1 = 28.92348878) | Skewed |
DESTINATION_ZIP is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
ORIGIN_ZIP is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
ACCESSORIAL_CHARGE has 291490 (59.4%) zeros | Zeros |
DUTIES_AND_TAXES_CHARGES has 459405 (93.6%) zeros | Zeros |
SHIP_WEIGHT has 13078 (2.7%) zeros | Zeros |
TOTAL_PAID has 37073 (7.6%) zeros | Zeros |
Reproduction
| Analysis started | 2024-02-16 08:23:05.819526 |
|---|---|
| Analysis finished | 2024-02-16 08:24:28.347539 |
| Duration | 1 minute and 22.53 seconds |
| Software version | ydata-profiling vv4.6.4 |
| Download configuration | config.json |
Unnamed: 0
Real number (ℝ)
HIGH CORRELATION
| Distinct | 128660 |
|---|---|
| Distinct (%) | 26.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 58477.814 |
| Minimum | 0 |
|---|---|
| Maximum | 128659 |
| Zeros | 5 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4909 |
| Q1 | 27150.25 |
| median | 57835.5 |
| Q3 | 88520.75 |
| 95-th percentile | 115896.95 |
| Maximum | 128659 |
| Range | 128659 |
| Interquartile range (IQR) | 61370.5 |
Descriptive statistics
| Standard deviation | 35692.281 |
|---|---|
| Coefficient of variation (CV) | 0.61035595 |
| Kurtosis | -1.1517576 |
| Mean | 58477.814 |
| Median Absolute Deviation (MAD) | 30685.5 |
| Skewness | 0.08844712 |
| Sum | 2.8710384 × 1010 |
| Variance | 1.273939 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 5 | < 0.1% |
| 9429 | 5 | < 0.1% |
| 9418 | 5 | < 0.1% |
| 9419 | 5 | < 0.1% |
| 9420 | 5 | < 0.1% |
| 9421 | 5 | < 0.1% |
| 9422 | 5 | < 0.1% |
| 9423 | 5 | < 0.1% |
| 9424 | 5 | < 0.1% |
| 9425 | 5 | < 0.1% |
| Other values (128650) | 490912 |
| Value | Count | Frequency (%) |
| 0 | 5 | |
| 1 | 5 | |
| 2 | 5 | |
| 3 | 5 | |
| 4 | 5 | |
| 5 | 5 | |
| 6 | 5 | |
| 7 | 5 | |
| 8 | 5 | |
| 9 | 5 |
| Value | Count | Frequency (%) |
| 128659 | 1 | |
| 128658 | 1 | |
| 128657 | 1 | |
| 128656 | 1 | |
| 128655 | 1 | |
| 128654 | 1 | |
| 128653 | 1 | |
| 128652 | 1 | |
| 128651 | 1 | |
| 128650 | 1 |
ACCESSORIAL_CHARGE
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 9746 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.881376 |
| Minimum | -13210.207 |
|---|---|
| Maximum | 3074.76 |
| Zeros | 291490 |
| Zeros (%) | 59.4% |
| Negative | 6590 |
| Negative (%) | 1.3% |
| Memory size | 3.7 MiB |
Quantile statistics
| Minimum | -13210.207 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 4.32306 |
| 95-th percentile | 51.1146 |
| Maximum | 3074.76 |
| Range | 16284.967 |
| Interquartile range (IQR) | 4.32306 |
Descriptive statistics
| Standard deviation | 65.637867 |
|---|---|
| Coefficient of variation (CV) | 5.5244333 |
| Kurtosis | 8275.9079 |
| Mean | 11.881376 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -32.242289 |
| Sum | 5833304 |
| Variance | 4308.3296 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 291490 | |
| 1.1826 | 26029 | 5.3% |
| 1.69506 | 6640 | 1.4% |
| 1.27458 | 6409 | 1.3% |
| 22.338 | 5600 | 1.1% |
| 2.628 | 5060 | 1.0% |
| 0.0657 | 4091 | 0.8% |
| 11.1033 | 3940 | 0.8% |
| 4.32306 | 3730 | 0.8% |
| 39.42 | 3638 | 0.7% |
| Other values (9736) | 134335 |
| Value | Count | Frequency (%) |
| -13210.20702 | 1 | |
| -12053.79504 | 2 | |
| -2169.97902 | 1 | |
| -1719.67122 | 1 | |
| -1717.25346 | 1 | |
| -1490.06286 | 2 | |
| -1473.1254 | 1 | |
| -1405.46754 | 2 | |
| -1240.65252 | 2 | |
| -1145.55834 | 1 |
| Value | Count | Frequency (%) |
| 3074.76 | 1 | |
| 2979.495 | 1 | |
| 2794.1553 | 1 | |
| 2693.7 | 2 | |
| 2681.874 | 1 | |
| 2601.72 | 1 | |
| 2588.58 | 1 | |
| 2584.1124 | 2 | |
| 2557.7667 | 1 | |
| 2424.33 | 2 |
CARRIER_NAME2
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.7 MiB |
| Nicole Brooks | |
|---|---|
| Timothy Parks | |
| Randall Hall | 8568 |
| Kimberly Flynn | 606 |
Length
| Max length | 14 |
|---|---|
| Median length | 13 |
| Mean length | 12.983783 |
| Min length | 12 |
Characters and Unicode
| Total characters | 6374544 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Randall Hall |
|---|---|
| 2nd row | Randall Hall |
| 3rd row | Randall Hall |
| 4th row | Randall Hall |
| 5th row | Randall Hall |
Common Values
| Value | Count | Frequency (%) |
| Nicole Brooks | 436936 | |
| Timothy Parks | 44852 | 9.1% |
| Randall Hall | 8568 | 1.7% |
| Kimberly Flynn | 606 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| nicole | 436936 | |
| brooks | 436936 | |
| timothy | 44852 | 4.6% |
| parks | 44852 | 4.6% |
| randall | 8568 | 0.9% |
| hall | 8568 | 0.9% |
| kimberly | 606 | 0.1% |
| flynn | 606 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 1355660 | |
| 490962 | 7.7% | |
| r | 482394 | 7.6% |
| i | 482394 | 7.6% |
| k | 481788 | 7.6% |
| s | 481788 | 7.6% |
| l | 472420 | 7.4% |
| e | 437542 | 6.9% |
| N | 436936 | 6.9% |
| c | 436936 | 6.9% |
| Other values (15) | 815724 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 4901658 | |
| Uppercase Letter | 981924 | 15.4% |
| Space Separator | 490962 | 7.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 1355660 | |
| r | 482394 | 9.8% |
| i | 482394 | 9.8% |
| k | 481788 | 9.8% |
| s | 481788 | 9.8% |
| l | 472420 | 9.6% |
| e | 437542 | 8.9% |
| c | 436936 | 8.9% |
| a | 70556 | 1.4% |
| y | 46064 | 0.9% |
| Other values (6) | 154116 | 3.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 436936 | |
| B | 436936 | |
| P | 44852 | 4.6% |
| T | 44852 | 4.6% |
| R | 8568 | 0.9% |
| H | 8568 | 0.9% |
| K | 606 | 0.1% |
| F | 606 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 490962 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5883582 | |
| Common | 490962 | 7.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 1355660 | |
| r | 482394 | 8.2% |
| i | 482394 | 8.2% |
| k | 481788 | 8.2% |
| s | 481788 | 8.2% |
| l | 472420 | 8.0% |
| e | 437542 | 7.4% |
| N | 436936 | 7.4% |
| c | 436936 | 7.4% |
| B | 436936 | 7.4% |
| Other values (14) | 378788 | 6.4% |
Common
| Value | Count | Frequency (%) |
| 490962 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6374544 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 1355660 | |
| 490962 | 7.7% | |
| r | 482394 | 7.6% |
| i | 482394 | 7.6% |
| k | 481788 | 7.6% |
| s | 481788 | 7.6% |
| l | 472420 | 7.4% |
| e | 437542 | 6.9% |
| N | 436936 | 6.9% |
| c | 436936 | 6.9% |
| Other values (15) | 815724 |
DELIVERY_DATE
Date
MISSING
| Distinct | 1458 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 24481 |
| Missing (%) | 5.0% |
| Memory size | 3.7 MiB |
| Minimum | 2019-06-18 00:00:00 |
|---|---|
| Maximum | 2024-01-25 00:00:00 |
Histogram with fixed size bins (bins=50)
DESTINATION_CITY
Text
MISSING
| Distinct | 4291 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 9362 |
| Missing (%) | 1.9% |
| Memory size | 3.7 MiB |
Length
| Max length | 30 |
|---|---|
| Median length | 29 |
| Mean length | 8.2117359 |
| Min length | 2 |
Characters and Unicode
| Total characters | 3954772 |
|---|---|
| Distinct characters | 76 |
| Distinct categories | 11 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1118 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | DESOTO |
|---|---|
| 2nd row | DESOTO |
| 3rd row | SAINT ALBANS |
| 4th row | BROKEN ARROW |
| 5th row | BROKEN ARROW |
| Value | Count | Frequency (%) |
| san | 148175 | |
| diego | 147656 | |
| fairburn | 79894 | |
| desoto | 39044 | 5.9% |
| mabank | 34298 | 5.1% |
| ontario | 16402 | 2.5% |
| broken | 7441 | 1.1% |
| arrow | 7436 | 1.1% |
| houston | 6885 | 1.0% |
| oceanside | 6455 | 1.0% |
| Other values (3648) | 172738 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 430200 | |
| N | 380637 | 9.6% |
| O | 359818 | 9.1% |
| E | 336220 | 8.5% |
| I | 319754 | 8.1% |
| R | 274467 | 6.9% |
| S | 261561 | 6.6% |
| D | 233915 | 5.9% |
| 184862 | 4.7% | |
| G | 177345 | 4.5% |
| Other values (66) | 995993 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 3635632 | |
| Space Separator | 184862 | 4.7% |
| Lowercase Letter | 132431 | 3.3% |
| Other Punctuation | 912 | < 0.1% |
| Dash Punctuation | 642 | < 0.1% |
| Decimal Number | 247 | < 0.1% |
| Open Punctuation | 26 | < 0.1% |
| Close Punctuation | 16 | < 0.1% |
| Connector Punctuation | 2 | < 0.1% |
| Math Symbol | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 430200 | |
| N | 380637 | |
| O | 359818 | |
| E | 336220 | |
| I | 319754 | |
| R | 274467 | 7.5% |
| S | 261561 | 7.2% |
| D | 233915 | 6.4% |
| G | 177345 | 4.9% |
| B | 149208 | 4.1% |
| Other values (16) | 712507 |
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 21253 | |
| e | 19795 | |
| a | 17649 | |
| n | 15491 | |
| i | 10033 | |
| t | 8882 | |
| r | 5967 | 4.5% |
| g | 5756 | 4.3% |
| l | 5167 | 3.9% |
| b | 2952 | 2.2% |
| Other values (16) | 19486 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 87 | |
| 0 | 30 | 12.1% |
| 2 | 24 | 9.7% |
| 6 | 23 | 9.3% |
| 7 | 23 | 9.3% |
| 9 | 15 | 6.1% |
| 4 | 15 | 6.1% |
| 5 | 12 | 4.9% |
| 8 | 9 | 3.6% |
| 3 | 9 | 3.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 687 | |
| . | 149 | 16.3% |
| ' | 51 | 5.6% |
| / | 16 | 1.8% |
| ? | 4 | 0.4% |
| & | 3 | 0.3% |
| @ | 2 | 0.2% |
Space Separator
| Value | Count | Frequency (%) |
| 184862 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 642 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 26 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 16 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 2 |
Math Symbol
| Value | Count | Frequency (%) |
| < | 1 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3768063 | |
| Common | 186709 | 4.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 430200 | |
| N | 380637 | |
| O | 359818 | |
| E | 336220 | 8.9% |
| I | 319754 | 8.5% |
| R | 274467 | 7.3% |
| S | 261561 | 6.9% |
| D | 233915 | 6.2% |
| G | 177345 | 4.7% |
| B | 149208 | 4.0% |
| Other values (42) | 844938 |
Common
| Value | Count | Frequency (%) |
| 184862 | ||
| , | 687 | 0.4% |
| - | 642 | 0.3% |
| . | 149 | 0.1% |
| 1 | 87 | < 0.1% |
| ' | 51 | < 0.1% |
| 0 | 30 | < 0.1% |
| ( | 26 | < 0.1% |
| 2 | 24 | < 0.1% |
| 6 | 23 | < 0.1% |
| Other values (14) | 128 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3954772 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 430200 | |
| N | 380637 | 9.6% |
| O | 359818 | 9.1% |
| E | 336220 | 8.5% |
| I | 319754 | 8.1% |
| R | 274467 | 6.9% |
| S | 261561 | 6.6% |
| D | 233915 | 5.9% |
| 184862 | 4.7% | |
| G | 177345 | 4.5% |
| Other values (66) | 995993 |
| Distinct | 99 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1714 |
| Missing (%) | 0.3% |
| Memory size | 3.7 MiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 978496 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | US |
|---|---|
| 2nd row | US |
| 3rd row | US |
| 4th row | US |
| 5th row | US |
| Value | Count | Frequency (%) |
| us | 461576 | |
| cz | 7453 | 1.5% |
| be | 2959 | 0.6% |
| de | 2083 | 0.4% |
| gb | 2078 | 0.4% |
| mx | 1871 | 0.4% |
| au | 1223 | 0.2% |
| ch | 887 | 0.2% |
| ca | 786 | 0.2% |
| sg | 543 | 0.1% |
| Other values (89) | 7789 | 1.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 462970 | |
| S | 462330 | |
| C | 9961 | 1.0% |
| Z | 7721 | 0.8% |
| E | 5840 | 0.6% |
| B | 5603 | 0.6% |
| D | 3320 | 0.3% |
| G | 3218 | 0.3% |
| M | 2846 | 0.3% |
| A | 2782 | 0.3% |
| Other values (16) | 11905 | 1.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 978496 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 462970 | |
| S | 462330 | |
| C | 9961 | 1.0% |
| Z | 7721 | 0.8% |
| E | 5840 | 0.6% |
| B | 5603 | 0.6% |
| D | 3320 | 0.3% |
| G | 3218 | 0.3% |
| M | 2846 | 0.3% |
| A | 2782 | 0.3% |
| Other values (16) | 11905 | 1.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 978496 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| U | 462970 | |
| S | 462330 | |
| C | 9961 | 1.0% |
| Z | 7721 | 0.8% |
| E | 5840 | 0.6% |
| B | 5603 | 0.6% |
| D | 3320 | 0.3% |
| G | 3218 | 0.3% |
| M | 2846 | 0.3% |
| A | 2782 | 0.3% |
| Other values (16) | 11905 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 978496 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| U | 462970 | |
| S | 462330 | |
| C | 9961 | 1.0% |
| Z | 7721 | 0.8% |
| E | 5840 | 0.6% |
| B | 5603 | 0.6% |
| D | 3320 | 0.3% |
| G | 3218 | 0.3% |
| M | 2846 | 0.3% |
| A | 2782 | 0.3% |
| Other values (16) | 11905 | 1.2% |
DESTINATION_RECEIVER_NAME2
Text
MISSING
| Distinct | 14797 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 21624 |
| Missing (%) | 4.4% |
| Memory size | 3.7 MiB |
Length
| Max length | 29 |
|---|---|
| Median length | 26 |
| Mean length | 13.859879 |
| Min length | 7 |
Characters and Unicode
| Total characters | 6504968 |
|---|---|
| Distinct characters | 54 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 6427 ? |
|---|---|
| Unique (%) | 1.4% |
Sample
| 1st row | Christopher Delgado |
|---|---|
| 2nd row | Christopher Delgado |
| 3rd row | Christine Chang |
| 4th row | Sarah Mason |
| 5th row | Sarah Mason |
| Value | Count | Frequency (%) |
| james | 50943 | 5.3% |
| franklin | 47895 | 5.0% |
| christine | 41662 | 4.3% |
| rice | 41580 | 4.3% |
| johnson | 41361 | 4.3% |
| jennifer | 41256 | 4.3% |
| christopher | 14641 | 1.5% |
| hernandez | 13957 | 1.4% |
| brown | 13840 | 1.4% |
| mrs | 12879 | 1.3% |
| Other values (1577) | 642942 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 664554 | 10.2% |
| n | 646458 | 9.9% |
| 493618 | 7.6% | |
| a | 473791 | 7.3% |
| r | 470245 | 7.2% |
| i | 467619 | 7.2% |
| s | 349397 | 5.4% |
| o | 335198 | 5.2% |
| l | 268705 | 4.1% |
| h | 224182 | 3.4% |
| Other values (44) | 2111201 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 5021860 | |
| Uppercase Letter | 973444 | 15.0% |
| Space Separator | 493618 | 7.6% |
| Other Punctuation | 16046 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 664554 | |
| n | 646458 | |
| a | 473791 | |
| r | 470245 | |
| i | 467619 | |
| s | 349397 | 7.0% |
| o | 335198 | 6.7% |
| l | 268705 | 5.4% |
| h | 224182 | 4.5% |
| t | 202492 | 4.0% |
| Other values (16) | 919219 |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 209287 | |
| C | 92391 | |
| R | 89294 | |
| M | 76332 | 7.8% |
| S | 59672 | 6.1% |
| F | 57817 | 5.9% |
| H | 53799 | 5.5% |
| A | 46718 | 4.8% |
| B | 43238 | 4.4% |
| D | 37712 | 3.9% |
| Other values (16) | 207184 |
Space Separator
| Value | Count | Frequency (%) |
| 493618 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 16046 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5995304 | |
| Common | 509664 | 7.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 664554 | 11.1% |
| n | 646458 | 10.8% |
| a | 473791 | 7.9% |
| r | 470245 | 7.8% |
| i | 467619 | 7.8% |
| s | 349397 | 5.8% |
| o | 335198 | 5.6% |
| l | 268705 | 4.5% |
| h | 224182 | 3.7% |
| J | 209287 | 3.5% |
| Other values (42) | 1885868 |
Common
| Value | Count | Frequency (%) |
| 493618 | ||
| . | 16046 | 3.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6504968 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 664554 | 10.2% |
| n | 646458 | 9.9% |
| 493618 | 7.6% | |
| a | 473791 | 7.3% |
| r | 470245 | 7.2% |
| i | 467619 | 7.2% |
| s | 349397 | 5.4% |
| o | 335198 | 5.2% |
| l | 268705 | 4.1% |
| h | 224182 | 3.4% |
| Other values (44) | 2111201 |
DESTINATION_ZIP
Unsupported
MISSING REJECTED UNSUPPORTED
| Missing | 9393 |
|---|---|
| Missing (%) | 1.9% |
| Memory size | 3.7 MiB |
DUTIES_AND_TAXES_CHARGES
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 9957 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 60.585278 |
| Minimum | -19.71 |
|---|---|
| Maximum | 50488.006 |
| Zeros | 459405 |
| Zeros (%) | 93.6% |
| Negative | 26 |
| Negative (%) | < 0.1% |
| Memory size | 3.7 MiB |
Quantile statistics
| Minimum | -19.71 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 31.982103 |
| Maximum | 50488.006 |
| Range | 50507.716 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 687.02468 |
|---|---|
| Coefficient of variation (CV) | 11.339796 |
| Kurtosis | 1639.7486 |
| Mean | 60.585278 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 33.583184 |
| Sum | 29745069 |
| Variance | 472002.91 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 459405 | |
| 19.71 | 4604 | 0.9% |
| 38.97324 | 187 | < 0.1% |
| 35.78022 | 168 | < 0.1% |
| 45.99 | 158 | < 0.1% |
| 36.4635 | 142 | < 0.1% |
| 35.20206 | 137 | < 0.1% |
| 13.14 | 55 | < 0.1% |
| 25.59672 | 50 | < 0.1% |
| 41.61438 | 48 | < 0.1% |
| Other values (9947) | 26008 | 5.3% |
| Value | Count | Frequency (%) |
| -19.71 | 12 | < 0.1% |
| -17.35794 | 2 | < 0.1% |
| -11.57634 | 2 | < 0.1% |
| -9.198 | 2 | < 0.1% |
| -8.69868 | 2 | < 0.1% |
| -8.61984 | 2 | < 0.1% |
| -7.21386 | 2 | < 0.1% |
| -4.70412 | 2 | < 0.1% |
| 0 | 459405 | |
| 0.09198 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 50488.00596 | 4 | |
| 48382.09758 | 4 | |
| 46701.11052 | 4 | |
| 42525.19224 | 4 | |
| 41738.39532 | 4 | |
| 39861.51714 | 3 | |
| 39306.03678 | 4 | |
| 38352.92688 | 4 | |
| 37036.8639 | 2 | |
| 36297.5418 | 4 |
HEIGHT
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 139 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 294158 |
| Missing (%) | 59.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.831787 |
| Minimum | 0 |
|---|---|
| Maximum | 302 |
| Zeros | 524 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 6 |
| median | 8 |
| Q3 | 12 |
| 95-th percentile | 25 |
| Maximum | 302 |
| Range | 302 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 10.915439 |
|---|---|
| Coefficient of variation (CV) | 1.0077228 |
| Kurtosis | 47.152331 |
| Mean | 10.831787 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 5.5305245 |
| Sum | 2131739 |
| Variance | 119.14681 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5 | 22408 | 4.6% |
| 6 | 20912 | 4.3% |
| 8 | 19727 | 4.0% |
| 12 | 18681 | 3.8% |
| 7 | 17367 | 3.5% |
| 10 | 14116 | 2.9% |
| 4 | 12659 | 2.6% |
| 9 | 10776 | 2.2% |
| 13 | 8353 | 1.7% |
| 11 | 6678 | 1.4% |
| Other values (129) | 45127 | 9.2% |
| (Missing) | 294158 |
| Value | Count | Frequency (%) |
| 0 | 524 | 0.1% |
| 1 | 2870 | 0.6% |
| 2 | 2356 | 0.5% |
| 3 | 4301 | 0.9% |
| 4 | 12659 | |
| 5 | 22408 | |
| 6 | 20912 | |
| 7 | 17367 | |
| 8 | 19727 | |
| 9 | 10776 |
| Value | Count | Frequency (%) |
| 302 | 1 | < 0.1% |
| 213 | 2 | < 0.1% |
| 177 | 1 | < 0.1% |
| 168 | 1 | < 0.1% |
| 165 | 1 | < 0.1% |
| 160 | 77 | |
| 156 | 2 | < 0.1% |
| 155 | 2 | < 0.1% |
| 153 | 6 | < 0.1% |
| 150 | 1 | < 0.1% |
LENGTH
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 152 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 294158 |
| Missing (%) | 59.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.500025 |
| Minimum | 0 |
|---|---|
| Maximum | 256 |
| Zeros | 330 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 11 |
| median | 14 |
| Q3 | 24 |
| 95-th percentile | 45 |
| Maximum | 256 |
| Range | 256 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 15.397902 |
|---|---|
| Coefficient of variation (CV) | 0.78963495 |
| Kurtosis | 34.919621 |
| Mean | 19.500025 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 4.075631 |
| Sum | 3837683 |
| Variance | 237.09537 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 12 | 28718 | 5.8% |
| 10 | 14558 | 3.0% |
| 8 | 12911 | 2.6% |
| 11 | 9627 | 2.0% |
| 13 | 8956 | 1.8% |
| 15 | 8168 | 1.7% |
| 14 | 7934 | 1.6% |
| 9 | 7589 | 1.5% |
| 16 | 7460 | 1.5% |
| 20 | 6770 | 1.4% |
| Other values (142) | 84113 | 17.1% |
| (Missing) | 294158 |
| Value | Count | Frequency (%) |
| 0 | 330 | 0.1% |
| 1 | 707 | 0.1% |
| 2 | 1102 | 0.2% |
| 3 | 165 | < 0.1% |
| 4 | 559 | 0.1% |
| 5 | 422 | 0.1% |
| 6 | 3953 | 0.8% |
| 7 | 3212 | 0.7% |
| 8 | 12911 | |
| 9 | 7589 |
| Value | Count | Frequency (%) |
| 256 | 1 | < 0.1% |
| 250 | 83 | |
| 216 | 9 | < 0.1% |
| 215 | 1 | < 0.1% |
| 213 | 5 | < 0.1% |
| 209 | 19 | < 0.1% |
| 207 | 1 | < 0.1% |
| 200 | 2 | < 0.1% |
| 194 | 2 | < 0.1% |
| 193 | 2 | < 0.1% |
MODE
Categorical
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.7 MiB |
| Ground | |
|---|---|
| Air |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.1771237 |
| Min length | 3 |
Characters and Unicode
| Total characters | 2541771 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Air |
|---|---|
| 2nd row | Air |
| 3rd row | Ground |
| 4th row | Ground |
| 5th row | Ground |
Common Values
| Value | Count | Frequency (%) |
| Ground | 356295 | |
| Air | 134667 | 27.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| ground | 356295 | |
| air | 134667 | 27.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 490962 | |
| G | 356295 | |
| o | 356295 | |
| u | 356295 | |
| n | 356295 | |
| d | 356295 | |
| A | 134667 | 5.3% |
| i | 134667 | 5.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2050809 | |
| Uppercase Letter | 490962 | 19.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 490962 | |
| o | 356295 | |
| u | 356295 | |
| n | 356295 | |
| d | 356295 | |
| i | 134667 | 6.6% |
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 356295 | |
| A | 134667 | 27.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2541771 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 490962 | |
| G | 356295 | |
| o | 356295 | |
| u | 356295 | |
| n | 356295 | |
| d | 356295 | |
| A | 134667 | 5.3% |
| i | 134667 | 5.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2541771 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 490962 | |
| G | 356295 | |
| o | 356295 | |
| u | 356295 | |
| n | 356295 | |
| d | 356295 | |
| A | 134667 | 5.3% |
| i | 134667 | 5.3% |
ORIGIN_CITY
Text
| Distinct | 2622 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 766 |
| Missing (%) | 0.2% |
| Memory size | 3.7 MiB |
Length
| Max length | 30 |
|---|---|
| Median length | 23 |
| Mean length | 8.6240749 |
| Min length | 3 |
Characters and Unicode
| Total characters | 4227487 |
|---|---|
| Distinct characters | 63 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 693 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | MABANK |
|---|---|
| 2nd row | MABANK |
| 3rd row | MABANK |
| 4th row | MCKINNEY |
| 5th row | MCKINNEY |
| Value | Count | Frequency (%) |
| san | 103959 | 15.1% |
| diego | 99930 | 14.5% |
| fairburn | 62507 | 9.1% |
| ontario | 19088 | 2.8% |
| lake | 14144 | 2.1% |
| city | 11283 | 1.6% |
| mabank | 9939 | 1.4% |
| forest | 9667 | 1.4% |
| santa | 9498 | 1.4% |
| houston | 9330 | 1.4% |
| Other values (2244) | 339031 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 428484 | 10.1% |
| N | 394288 | 9.3% |
| E | 319496 | 7.6% |
| I | 317653 | 7.5% |
| O | 312786 | 7.4% |
| R | 295974 | 7.0% |
| S | 253723 | 6.0% |
| 198180 | 4.7% | |
| D | 177578 | 4.2% |
| L | 170336 | 4.0% |
| Other values (53) | 1358989 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 3723582 | |
| Lowercase Letter | 305252 | 7.2% |
| Space Separator | 198180 | 4.7% |
| Dash Punctuation | 285 | < 0.1% |
| Other Punctuation | 166 | < 0.1% |
| Decimal Number | 22 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 428484 | |
| N | 394288 | |
| E | 319496 | 8.6% |
| I | 317653 | 8.5% |
| O | 312786 | 8.4% |
| R | 295974 | 7.9% |
| S | 253723 | 6.8% |
| D | 177578 | 4.8% |
| L | 170336 | 4.6% |
| T | 164207 | 4.4% |
| Other values (16) | 889057 |
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 37809 | |
| n | 37554 | |
| a | 35134 | |
| e | 32228 | |
| i | 32029 | |
| g | 24269 | |
| t | 17144 | 5.6% |
| r | 16212 | 5.3% |
| s | 12167 | 4.0% |
| l | 11356 | 3.7% |
| Other values (15) | 49350 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 10 | |
| 1 | 5 | |
| 3 | 2 | 9.1% |
| 0 | 2 | 9.1% |
| 8 | 1 | 4.5% |
| 9 | 1 | 4.5% |
| 4 | 1 | 4.5% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 157 | |
| , | 7 | 4.2% |
| / | 2 | 1.2% |
Space Separator
| Value | Count | Frequency (%) |
| 198180 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 285 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4028834 | |
| Common | 198653 | 4.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 428484 | 10.6% |
| N | 394288 | 9.8% |
| E | 319496 | 7.9% |
| I | 317653 | 7.9% |
| O | 312786 | 7.8% |
| R | 295974 | 7.3% |
| S | 253723 | 6.3% |
| D | 177578 | 4.4% |
| L | 170336 | 4.2% |
| T | 164207 | 4.1% |
| Other values (41) | 1194309 |
Common
| Value | Count | Frequency (%) |
| 198180 | ||
| - | 285 | 0.1% |
| . | 157 | 0.1% |
| 2 | 10 | < 0.1% |
| , | 7 | < 0.1% |
| 1 | 5 | < 0.1% |
| / | 2 | < 0.1% |
| 3 | 2 | < 0.1% |
| 0 | 2 | < 0.1% |
| 8 | 1 | < 0.1% |
| Other values (2) | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4227487 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 428484 | 10.1% |
| N | 394288 | 9.3% |
| E | 319496 | 7.6% |
| I | 317653 | 7.5% |
| O | 312786 | 7.4% |
| R | 295974 | 7.0% |
| S | 253723 | 6.0% |
| 198180 | 4.7% | |
| D | 177578 | 4.2% |
| L | 170336 | 4.0% |
| Other values (53) | 1358989 |
ORIGIN_COUNTRY
Text
| Distinct | 55 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 124 |
| Missing (%) | < 0.1% |
| Memory size | 3.7 MiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 981676 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 10 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | US |
|---|---|
| 2nd row | US |
| 3rd row | US |
| 4th row | US |
| 5th row | US |
| Value | Count | Frequency (%) |
| us | 471318 | |
| gb | 9659 | 2.0% |
| de | 1769 | 0.4% |
| be | 1691 | 0.3% |
| it | 1461 | 0.3% |
| ca | 1168 | 0.2% |
| nl | 1126 | 0.2% |
| ch | 948 | 0.2% |
| cz | 758 | 0.2% |
| mx | 478 | 0.1% |
| Other values (45) | 462 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 471479 | |
| U | 471338 | |
| B | 11372 | 1.2% |
| G | 9685 | 1.0% |
| E | 3610 | 0.4% |
| C | 2913 | 0.3% |
| D | 1784 | 0.2% |
| T | 1531 | 0.2% |
| I | 1493 | 0.2% |
| A | 1251 | 0.1% |
| Other values (16) | 5220 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 981676 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 471479 | |
| U | 471338 | |
| B | 11372 | 1.2% |
| G | 9685 | 1.0% |
| E | 3610 | 0.4% |
| C | 2913 | 0.3% |
| D | 1784 | 0.2% |
| T | 1531 | 0.2% |
| I | 1493 | 0.2% |
| A | 1251 | 0.1% |
| Other values (16) | 5220 | 0.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 981676 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 471479 | |
| U | 471338 | |
| B | 11372 | 1.2% |
| G | 9685 | 1.0% |
| E | 3610 | 0.4% |
| C | 2913 | 0.3% |
| D | 1784 | 0.2% |
| T | 1531 | 0.2% |
| I | 1493 | 0.2% |
| A | 1251 | 0.1% |
| Other values (16) | 5220 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 981676 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 471479 | |
| U | 471338 | |
| B | 11372 | 1.2% |
| G | 9685 | 1.0% |
| E | 3610 | 0.4% |
| C | 2913 | 0.3% |
| D | 1784 | 0.2% |
| T | 1531 | 0.2% |
| I | 1493 | 0.2% |
| A | 1251 | 0.1% |
| Other values (16) | 5220 | 0.5% |
ORIGIN_SENDER_NAME2
Real number (ℝ)
| Distinct | 5742 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 1504 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.8186745 × 1012 |
| Minimum | 4.068914 × 108 |
|---|---|
| Maximum | 9.9994377 × 1012 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.7 MiB |
Quantile statistics
| Minimum | 4.068914 × 108 |
|---|---|
| 5-th percentile | 5.2253942 × 1011 |
| Q1 | 2.6058437 × 1012 |
| median | 4.2706907 × 1012 |
| Q3 | 7.2160595 × 1012 |
| 95-th percentile | 9.7302183 × 1012 |
| Maximum | 9.9994377 × 1012 |
| Range | 9.9990308 × 1012 |
| Interquartile range (IQR) | 4.6102158 × 1012 |
Descriptive statistics
| Standard deviation | 2.7934191 × 1012 |
|---|---|
| Coefficient of variation (CV) | 0.57970696 |
| Kurtosis | -1.003026 |
| Mean | 4.8186745 × 1012 |
| Median Absolute Deviation (MAD) | 2.1953369 × 1012 |
| Skewness | 0.19587517 |
| Sum | 2.3585388 × 1018 |
| Variance | 7.8031905 × 1024 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3.712043637 × 1012 | 47771 | 9.7% |
| 9.730218283 × 1012 | 16510 | 3.4% |
| 5.776435396 × 1012 | 14482 | 2.9% |
| 7.253516149 × 1012 | 14029 | 2.9% |
| 9.415680895 × 1012 | 9555 | 1.9% |
| 5.558939569 × 1012 | 9271 | 1.9% |
| 5.699567853 × 1011 | 8876 | 1.8% |
| 5.313890467 × 1012 | 8854 | 1.8% |
| 3.4987932 × 1012 | 7429 | 1.5% |
| 7.564786118 × 1012 | 7267 | 1.5% |
| Other values (5732) | 345414 |
| Value | Count | Frequency (%) |
| 406891400 | 4 | < 0.1% |
| 1259439177 | 1 | < 0.1% |
| 4146075779 | 1 | < 0.1% |
| 4413164861 | 1 | < 0.1% |
| 6915000203 | 2 | < 0.1% |
| 8207031698 | 1 | < 0.1% |
| 8753216181 | 1 | < 0.1% |
| 9305079568 | 1 | < 0.1% |
| 1.3367867 × 1010 | 3 | < 0.1% |
| 1.353208903 × 1010 | 210 |
| Value | Count | Frequency (%) |
| 9.999437707 × 1012 | 9 | < 0.1% |
| 9.994852334 × 1012 | 1 | < 0.1% |
| 9.994687059 × 1012 | 1 | < 0.1% |
| 9.992078515 × 1012 | 2 | < 0.1% |
| 9.990621479 × 1012 | 1 | < 0.1% |
| 9.9848107 × 1012 | 429 | |
| 9.983650091 × 1012 | 5 | < 0.1% |
| 9.981423103 × 1012 | 1 | < 0.1% |
| 9.979948911 × 1012 | 48 | < 0.1% |
| 9.976591847 × 1012 | 4 | < 0.1% |
ORIGIN_ZIP
Unsupported
REJECTED UNSUPPORTED
| Missing | 131 |
|---|---|
| Missing (%) | < 0.1% |
| Memory size | 3.7 MiB |
SHIP_DATE
Date
MISSING
| Distinct | 221129 |
|---|---|
| Distinct (%) | 46.4% |
| Missing | 14209 |
| Missing (%) | 2.9% |
| Memory size | 3.7 MiB |
| Minimum | 2018-09-20 00:00:00 |
|---|---|
| Maximum | 2024-01-19 21:39:00 |
Histogram with fixed size bins (bins=50)
MISSING
| Distinct | 1504 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 14209 |
| Missing (%) | 2.9% |
| Memory size | 3.7 MiB |
| Minimum | 2018-09-20 00:00:00 |
|---|---|
| Maximum | 2024-01-19 00:00:00 |
Histogram with fixed size bins (bins=50)
SHIP_WEIGHT
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 1111 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 852 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.928861 |
| Minimum | 0 |
|---|---|
| Maximum | 5662 |
| Zeros | 13078 |
| Zeros (%) | 2.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 10 |
| Q3 | 27 |
| 95-th percentile | 75 |
| Maximum | 5662 |
| Range | 5662 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 72.806616 |
|---|---|
| Coefficient of variation (CV) | 2.9205753 |
| Kurtosis | 478.59252 |
| Mean | 24.928861 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 16.767302 |
| Sum | 12217884 |
| Variance | 5300.8033 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2 | 49650 | 10.1% |
| 1 | 39926 | 8.1% |
| 3 | 32429 | 6.6% |
| 4 | 22682 | 4.6% |
| 5 | 21330 | 4.3% |
| 6 | 19822 | 4.0% |
| 7 | 17014 | 3.5% |
| 0 | 13078 | 2.7% |
| 10 | 13001 | 2.6% |
| 8 | 12823 | 2.6% |
| Other values (1101) | 248355 |
| Value | Count | Frequency (%) |
| 0 | 13078 | 2.7% |
| 1 | 39926 | |
| 2 | 49650 | |
| 3 | 32429 | |
| 4 | 22682 | |
| 5 | 21330 | |
| 6 | 19822 | 4.0% |
| 7 | 17014 | 3.5% |
| 8 | 12823 | 2.6% |
| 9 | 11471 | 2.3% |
| Value | Count | Frequency (%) |
| 5662 | 1 | |
| 5102 | 1 | |
| 3835 | 1 | |
| 3776 | 1 | |
| 3707 | 1 | |
| 3360 | 1 | |
| 3200 | 1 | |
| 3144 | 1 | |
| 3123 | 1 | |
| 2966 | 2 |
SHIP_WEIGHT_UNIT_OF_MEASURE
Categorical
IMBALANCE
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.7 MiB |
| POUNDS | |
|---|---|
| KILOGRAMS | 21768 |
| OUNCES | 19320 |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 6.1330123 |
| Min length | 6 |
Characters and Unicode
| Total characters | 3011076 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | POUNDS |
|---|---|
| 2nd row | POUNDS |
| 3rd row | POUNDS |
| 4th row | POUNDS |
| 5th row | POUNDS |
Common Values
| Value | Count | Frequency (%) |
| POUNDS | 449874 | |
| KILOGRAMS | 21768 | 4.4% |
| OUNCES | 19320 | 3.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| pounds | 449874 | |
| kilograms | 21768 | 4.4% |
| ounces | 19320 | 3.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 490962 | |
| S | 490962 | |
| U | 469194 | |
| N | 469194 | |
| P | 449874 | |
| D | 449874 | |
| K | 21768 | 0.7% |
| I | 21768 | 0.7% |
| L | 21768 | 0.7% |
| G | 21768 | 0.7% |
| Other values (5) | 103944 | 3.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 3011076 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 490962 | |
| S | 490962 | |
| U | 469194 | |
| N | 469194 | |
| P | 449874 | |
| D | 449874 | |
| K | 21768 | 0.7% |
| I | 21768 | 0.7% |
| L | 21768 | 0.7% |
| G | 21768 | 0.7% |
| Other values (5) | 103944 | 3.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3011076 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 490962 | |
| S | 490962 | |
| U | 469194 | |
| N | 469194 | |
| P | 449874 | |
| D | 449874 | |
| K | 21768 | 0.7% |
| I | 21768 | 0.7% |
| L | 21768 | 0.7% |
| G | 21768 | 0.7% |
| Other values (5) | 103944 | 3.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3011076 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 490962 | |
| S | 490962 | |
| U | 469194 | |
| N | 469194 | |
| P | 449874 | |
| D | 449874 | |
| K | 21768 | 0.7% |
| I | 21768 | 0.7% |
| L | 21768 | 0.7% |
| G | 21768 | 0.7% |
| Other values (5) | 103944 | 3.5% |
TOTAL_PAID
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 31227 |
|---|---|
| Distinct (%) | 6.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 118.04429 |
| Minimum | -13210.207 |
|---|---|
| Maximum | 75973.181 |
| Zeros | 37073 |
| Zeros (%) | 7.6% |
| Negative | 1308 |
| Negative (%) | 0.3% |
| Memory size | 3.7 MiB |
Quantile statistics
| Minimum | -13210.207 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 6.93792 |
| median | 10.1835 |
| Q3 | 25.41276 |
| 95-th percentile | 343.4001 |
| Maximum | 75973.181 |
| Range | 89183.388 |
| Interquartile range (IQR) | 18.47484 |
Descriptive statistics
| Standard deviation | 879.86033 |
|---|---|
| Coefficient of variation (CV) | 7.4536459 |
| Kurtosis | 1321.9818 |
| Mean | 118.04429 |
| Median Absolute Deviation (MAD) | 3.85002 |
| Skewness | 28.923489 |
| Sum | 57955260 |
| Variance | 774154.2 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 37073 | 7.6% |
| 6.80652 | 12687 | 2.6% |
| 6.68826 | 4866 | 1.0% |
| 6.84594 | 3506 | 0.7% |
| 6.93792 | 3356 | 0.7% |
| 6.66198 | 3164 | 0.6% |
| 6.7671 | 3024 | 0.6% |
| 6.92478 | 3001 | 0.6% |
| 6.88536 | 2842 | 0.6% |
| 6.8985 | 2706 | 0.6% |
| Other values (31217) | 414737 |
| Value | Count | Frequency (%) |
| -13210.20702 | 1 | |
| -750.05748 | 1 | |
| -526.02048 | 1 | |
| -413.02962 | 1 | |
| -325.50408 | 1 | |
| -324.17694 | 1 | |
| -253.57572 | 1 | |
| -237.7026 | 1 | |
| -235.25856 | 1 | |
| -222.63102 | 1 |
| Value | Count | Frequency (%) |
| 75973.1805 | 1 | < 0.1% |
| 68001.10308 | 2 | |
| 56563.98138 | 4 | |
| 54609.36696 | 4 | |
| 53059.16232 | 4 | |
| 50859.10584 | 4 | |
| 48814.14078 | 4 | |
| 44205.43032 | 4 | |
| 43615.56258 | 3 | |
| 42210.1476 | 2 |
TRACKING_NUMBER2
Text
| Distinct | 209873 |
|---|---|
| Distinct (%) | 42.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.7 MiB |
Length
| Max length | 28 |
|---|---|
| Median length | 26 |
| Mean length | 13.28049 |
| Min length | 6 |
Characters and Unicode
| Total characters | 6520216 |
|---|---|
| Distinct characters | 54 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 122753 ? |
|---|---|
| Unique (%) | 25.0% |
Sample
| 1st row | Paul Hayes |
|---|---|
| 2nd row | Madison Anderson |
| 3rd row | Joseph Larson |
| 4th row | Bryan Farley |
| 5th row | Bryan Farley |
| Value | Count | Frequency (%) |
| michael | 11275 | 1.1% |
| smith | 10820 | 1.1% |
| james | 8357 | 0.8% |
| johnson | 8311 | 0.8% |
| david | 7741 | 0.8% |
| john | 7095 | 0.7% |
| jennifer | 7085 | 0.7% |
| williams | 6931 | 0.7% |
| christopher | 6725 | 0.7% |
| thomas | 6707 | 0.7% |
| Other values (1588) | 922889 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 605533 | 9.3% |
| a | 601540 | 9.2% |
| 512974 | 7.9% | |
| n | 489291 | 7.5% |
| r | 468816 | 7.2% |
| i | 394719 | 6.1% |
| o | 351889 | 5.4% |
| l | 332090 | 5.1% |
| s | 294074 | 4.5% |
| t | 226906 | 3.5% |
| Other values (44) | 2242384 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 4976853 | |
| Uppercase Letter | 1020050 | 15.6% |
| Space Separator | 512974 | 7.9% |
| Other Punctuation | 10339 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 605533 | |
| a | 601540 | |
| n | 489291 | |
| r | 468816 | |
| i | 394719 | 7.9% |
| o | 351889 | 7.1% |
| l | 332090 | 6.7% |
| s | 294074 | 5.9% |
| t | 226906 | 4.6% |
| h | 219734 | 4.4% |
| Other values (16) | 992261 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 113634 | 11.1% |
| J | 101087 | 9.9% |
| S | 83639 | 8.2% |
| C | 76140 | 7.5% |
| D | 68300 | 6.7% |
| B | 63805 | 6.3% |
| R | 63043 | 6.2% |
| A | 62922 | 6.2% |
| W | 47979 | 4.7% |
| H | 46658 | 4.6% |
| Other values (16) | 292843 |
Space Separator
| Value | Count | Frequency (%) |
| 512974 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 10339 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5996903 | |
| Common | 523313 | 8.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 605533 | 10.1% |
| a | 601540 | 10.0% |
| n | 489291 | 8.2% |
| r | 468816 | 7.8% |
| i | 394719 | 6.6% |
| o | 351889 | 5.9% |
| l | 332090 | 5.5% |
| s | 294074 | 4.9% |
| t | 226906 | 3.8% |
| h | 219734 | 3.7% |
| Other values (42) | 2012311 |
Common
| Value | Count | Frequency (%) |
| 512974 | ||
| . | 10339 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6520216 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 605533 | 9.3% |
| a | 601540 | 9.2% |
| 512974 | 7.9% | |
| n | 489291 | 7.5% |
| r | 468816 | 7.2% |
| i | 394719 | 6.1% |
| o | 351889 | 5.4% |
| l | 332090 | 5.1% |
| s | 294074 | 4.5% |
| t | 226906 | 3.5% |
| Other values (44) | 2242384 |
WIDTH
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 119 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 294158 |
| Missing (%) | 59.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.374423 |
| Minimum | 1 |
|---|---|
| Maximum | 244 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 9 |
| median | 12 |
| Q3 | 17 |
| 95-th percentile | 35 |
| Maximum | 244 |
| Range | 243 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 11.306076 |
|---|---|
| Coefficient of variation (CV) | 0.7353821 |
| Kurtosis | 25.635513 |
| Mean | 15.374423 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 3.8070752 |
| Sum | 3025748 |
| Variance | 127.82735 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 12 | 31623 | 6.4% |
| 10 | 21138 | 4.3% |
| 8 | 18052 | 3.7% |
| 13 | 11845 | 2.4% |
| 9 | 10829 | 2.2% |
| 6 | 10043 | 2.0% |
| 16 | 8878 | 1.8% |
| 14 | 8177 | 1.7% |
| 11 | 7470 | 1.5% |
| 7 | 7401 | 1.5% |
| Other values (109) | 61348 | 12.5% |
| (Missing) | 294158 |
| Value | Count | Frequency (%) |
| 1 | 454 | 0.1% |
| 2 | 22 | < 0.1% |
| 3 | 555 | 0.1% |
| 4 | 1561 | 0.3% |
| 5 | 2201 | 0.4% |
| 6 | 10043 | |
| 7 | 7401 | 1.5% |
| 8 | 18052 | |
| 9 | 10829 | |
| 10 | 21138 |
| Value | Count | Frequency (%) |
| 244 | 1 | < 0.1% |
| 155 | 1 | < 0.1% |
| 153 | 1 | < 0.1% |
| 150 | 7 | < 0.1% |
| 145 | 86 | |
| 143 | 27 | < 0.1% |
| 137 | 12 | < 0.1% |
| 127 | 4 | < 0.1% |
| 126 | 4 | < 0.1% |
| 125 | 38 |
| ACCESSORIAL_CHARGE | CARRIER_NAME2 | DUTIES_AND_TAXES_CHARGES | HEIGHT | LENGTH | MODE | ORIGIN_SENDER_NAME2 | SHIP_WEIGHT | SHIP_WEIGHT_UNIT_OF_MEASURE | TOTAL_PAID | Unnamed: 0 | WIDTH | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACCESSORIAL_CHARGE | 1.000 | 0.008 | 0.381 | 0.258 | 0.319 | 0.040 | -0.048 | 0.161 | 0.011 | 0.664 | -0.233 | 0.352 |
| CARRIER_NAME2 | 0.008 | 1.000 | 0.742 | 0.254 | 0.054 | 0.530 | -0.105 | 0.049 | 0.468 | 0.470 | -0.524 | 0.213 |
| DUTIES_AND_TAXES_CHARGES | 0.381 | 0.742 | 1.000 | 0.304 | 0.171 | 0.073 | -0.125 | 0.136 | 0.054 | 0.412 | -0.382 | 0.295 |
| HEIGHT | 0.258 | 0.254 | 0.304 | 1.000 | 0.393 | 0.306 | -0.050 | 0.536 | 0.442 | 0.408 | -0.140 | 0.525 |
| LENGTH | 0.319 | 0.054 | 0.171 | 0.393 | 1.000 | 0.145 | -0.095 | 0.628 | 0.295 | 0.376 | -0.031 | 0.723 |
| MODE | 0.040 | 0.530 | 0.073 | 0.306 | 0.145 | 1.000 | 0.083 | 0.020 | 0.401 | -0.516 | 0.256 | -0.149 |
| ORIGIN_SENDER_NAME2 | -0.048 | -0.105 | -0.125 | -0.050 | -0.095 | 0.083 | 1.000 | -0.089 | 0.204 | -0.074 | 0.013 | -0.109 |
| SHIP_WEIGHT | 0.161 | 0.049 | 0.136 | 0.536 | 0.628 | 0.020 | -0.089 | 1.000 | 0.033 | 0.295 | -0.012 | 0.576 |
| SHIP_WEIGHT_UNIT_OF_MEASURE | 0.011 | 0.468 | 0.054 | 0.442 | 0.295 | 0.401 | 0.204 | 0.033 | 1.000 | -0.259 | 0.237 | -0.222 |
| TOTAL_PAID | 0.664 | 0.470 | 0.412 | 0.408 | 0.376 | -0.516 | -0.074 | 0.295 | -0.259 | 1.000 | -0.251 | 0.456 |
| Unnamed: 0 | -0.233 | -0.524 | -0.382 | -0.140 | -0.031 | 0.256 | 0.013 | -0.012 | 0.237 | -0.251 | 1.000 | -0.121 |
| WIDTH | 0.352 | 0.213 | 0.295 | 0.525 | 0.723 | -0.149 | -0.109 | 0.576 | -0.222 | 0.456 | -0.121 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| Unnamed: 0 | ACCESSORIAL_CHARGE | CARRIER_NAME2 | DELIVERY_DATE | DESTINATION_CITY | DESTINATION_COUNTRY | DESTINATION_RECEIVER_NAME2 | DESTINATION_ZIP | DUTIES_AND_TAXES_CHARGES | HEIGHT | LENGTH | MODE | ORIGIN_CITY | ORIGIN_COUNTRY | ORIGIN_SENDER_NAME2 | ORIGIN_ZIP | SHIP_DATE | SHIP_DATE_DAY_YEAR | SHIP_WEIGHT | SHIP_WEIGHT_UNIT_OF_MEASURE | TOTAL_PAID | TRACKING_NUMBER2 | WIDTH | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 0.0000 | Randall Hall | 2020-11-04 | DESOTO | US | Christopher Delgado | 75115 | 0.0 | NaN | NaN | Air | MABANK | US | 3.712044e+12 | 75147 | 2020-11-03 15:52:00 | 2020-11-03 | 1.0 | POUNDS | 13.82328 | Paul Hayes | NaN |
| 1 | 1 | 0.0000 | Randall Hall | 2020-11-02 | DESOTO | US | Christopher Delgado | 75115 | 0.0 | NaN | NaN | Air | MABANK | US | 3.712044e+12 | 75147 | 2020-10-30 14:53:00 | 2020-10-30 | 1.0 | POUNDS | 13.82328 | Madison Anderson | NaN |
| 2 | 2 | 3.9420 | Randall Hall | 2020-10-26 | SAINT ALBANS | US | Christine Chang | 25177 | 0.0 | NaN | NaN | Ground | MABANK | US | 3.712044e+12 | 75147 | 2020-10-22 14:15:00 | 2020-10-22 | NaN | POUNDS | 4.16538 | Joseph Larson | NaN |
| 3 | 3 | 41.4567 | Randall Hall | 2020-11-05 | BROKEN ARROW | US | Sarah Mason | 74012 | 0.0 | 6.0 | 10.0 | Ground | MCKINNEY | US | 2.213039e+11 | 75070 | 2020-11-03 15:44:00 | 2020-11-03 | 35.0 | POUNDS | 65.66058 | Bryan Farley | 9.0 |
| 4 | 4 | 17.9361 | Randall Hall | 2020-11-05 | BROKEN ARROW | US | Sarah Mason | 74012 | 0.0 | 6.0 | 10.0 | Ground | MCKINNEY | US | 2.213039e+11 | 75070 | 2020-11-03 15:44:00 | 2020-11-03 | 35.0 | POUNDS | 40.78656 | Bryan Farley | 10.0 |
| 5 | 5 | 137.9700 | Randall Hall | NaT | LAREDO | US | Scott Washington | 78045 | 0.0 | 12.0 | 16.0 | Air | FAIRBURN | US | 5.558940e+12 | 30213 | 2020-11-03 16:25:00 | 2020-11-03 | 4.0 | POUNDS | 236.69082 | Aaron Smith | 12.0 |
| 6 | 6 | 0.0000 | Randall Hall | 2020-11-04 | FAIRBURN | US | Jennifer Johnson | 30213 | 0.0 | NaN | NaN | Air | ATLANTA | US | 7.079584e+12 | 30354 | 2020-11-03 22:30:00 | 2020-11-03 | 4.0 | POUNDS | 20.20932 | Holly Conrad | NaN |
| 7 | 7 | 0.0000 | Randall Hall | 2020-10-30 | SAN DIEGO | US | James Franklin | 92123 | 0.0 | 8.0 | 10.0 | Ground | MIDLAND | US | 3.712044e+12 | 79706 | 2020-10-27 11:45:00 | 2020-10-27 | 3.0 | POUNDS | 15.92568 | Danielle Stevens | 8.0 |
| 8 | 8 | 11.8917 | Randall Hall | 2020-11-03 | AZTEC | US | John Green | 87410 | 0.0 | NaN | NaN | Air | MIDLAND | US | 6.978112e+12 | 79706 | 2020-11-02 13:23:00 | 2020-11-02 | 1.0 | POUNDS | 33.54642 | Peter Rodriguez | NaN |
| 9 | 9 | 28.2510 | Randall Hall | 2020-11-04 | CARRIZO SPRINGS | US | Adam Harris | 78834 | 0.0 | 9.0 | 24.0 | Air | MIDLAND | US | 5.963410e+12 | 79706 | 2020-11-03 14:57:00 | 2020-11-03 | 28.0 | POUNDS | 92.89980 | Aaron Smith | 20.0 |
| Unnamed: 0 | ACCESSORIAL_CHARGE | CARRIER_NAME2 | DELIVERY_DATE | DESTINATION_CITY | DESTINATION_COUNTRY | DESTINATION_RECEIVER_NAME2 | DESTINATION_ZIP | DUTIES_AND_TAXES_CHARGES | HEIGHT | LENGTH | MODE | ORIGIN_CITY | ORIGIN_COUNTRY | ORIGIN_SENDER_NAME2 | ORIGIN_ZIP | SHIP_DATE | SHIP_DATE_DAY_YEAR | SHIP_WEIGHT | SHIP_WEIGHT_UNIT_OF_MEASURE | TOTAL_PAID | TRACKING_NUMBER2 | WIDTH | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 490952 | 14127 | 28.22472 | Nicole Brooks | NaT | SLATON | US | Jenna Evans | 79364 | 0.0 | 8.0 | 8.0 | Air | SAN DIEGO | US | 2.168663e+12 | 92123 | NaT | NaT | 0.0 | KILOGRAMS | 232.31520 | Katherine Reid | 8.0 |
| 490953 | 14128 | 1.18260 | Nicole Brooks | 2024-01-17 | MABANK | US | Andrew Gonzalez | 75147 | 0.0 | 4.0 | 8.0 | Ground | San Diego | US | 5.057829e+12 | 92123 | 2024-01-10 19:56:00 | 2024-01-10 | 2.0 | POUNDS | 8.21250 | Benjamin May | 8.0 |
| 490954 | 14129 | 0.00000 | Nicole Brooks | 2024-01-17 | OCEANSIDE | US | Daniel Stewart | 92056 | 0.0 | 9.0 | 9.0 | Ground | POMONA | US | 3.616013e+12 | 91768 | 2024-01-16 21:37:00 | 2024-01-16 | 2.0 | POUNDS | 6.92478 | Courtney Strong | 9.0 |
| 490955 | 14130 | 1.18260 | Nicole Brooks | 2024-01-16 | KALKASKA | US | Gail Cook | 49646 | 0.0 | 1.0 | 11.0 | Ground | SAN DIEGO | US | 1.828520e+12 | 92123 | 2024-01-08 20:47:00 | 2024-01-08 | 2.0 | POUNDS | 8.51472 | Patricia Howard | 9.0 |
| 490956 | 14131 | 1.27458 | Nicole Brooks | 2024-01-18 | MABANK | US | Andrew Gonzalez | 75147 | 0.0 | 4.0 | 12.0 | Air | SAN DIEGO | US | 1.828520e+12 | 92123 | 2024-01-17 16:51:00 | 2024-01-17 | 7.0 | POUNDS | 26.81874 | Bonnie Douglas | 12.0 |
| 490957 | 14132 | 0.00000 | Nicole Brooks | 2024-01-18 | DESOTO | US | Edwin Bowers | 75115 | 0.0 | 6.0 | 12.0 | Air | San Diego | US | 5.057829e+12 | 92123 | 2024-01-17 16:51:00 | 2024-01-17 | 4.0 | POUNDS | 20.51154 | Leslie Wilkinson | 12.0 |
| 490958 | 14133 | 1.18260 | Nicole Brooks | 2024-01-16 | BALL GROUND | US | Carla Davis | 30107 | 0.0 | 1.0 | 11.0 | Ground | SAN DIEGO | US | 1.828520e+12 | 92123 | 2024-01-08 21:34:00 | 2024-01-08 | 2.0 | POUNDS | 8.51472 | Alvin Cowan | 9.0 |
| 490959 | 14134 | 0.00000 | Nicole Brooks | 2024-01-16 | SEWICKLEY | US | Daniel Graham | 15143 | 0.0 | 1.0 | 11.0 | Ground | SAN DIEGO | US | 1.828520e+12 | 92123 | 2024-01-08 21:39:00 | 2024-01-08 | 2.0 | POUNDS | 7.24014 | Ruth Dillon | 9.0 |
| 490960 | 14135 | 0.00000 | Nicole Brooks | 2024-01-19 | MIAMI | US | Lauren Taylor | 33122 | 0.0 | 8.0 | 27.0 | Air | SAN DIEGO | US | 1.828520e+12 | 92123 | 2024-01-18 16:44:00 | 2024-01-18 | 19.0 | POUNDS | 46.10826 | Juan Munoz | 17.0 |
| 490961 | 14136 | 1.18260 | Nicole Brooks | 2024-01-16 | TOPEKA | US | Connie Smith | 66618 | 0.0 | 4.0 | 36.0 | Ground | San Diego | US | 5.057829e+12 | 92123 | 2024-01-09 21:32:00 | 2024-01-09 | 27.0 | POUNDS | 15.41322 | Stephanie Gonzalez | 4.0 |